package com.be.beadmin.device.entity;


import cn.hutool.core.date.DateTime;
import com.alibaba.excel.annotation.format.DateTimeFormat;
import com.be.beadmin.common.entity.BaseEntity;
import lombok.Getter;
import lombok.Setter;
import java.util.Date;

import javax.persistence.*;



/**
 * @website
 * @description /
 * @author zty
 * @date 2023-08-26
 **/
@Entity
@Getter
@Setter
@Table(name="t_de_device_info")

public class DeviceInfo extends BaseEntity {

    @Column(name = "identification",columnDefinition = "VARCHAR(50) COMMENT '唯一标识'  not null")
    private String identification;

    @Column(name = "device_name",columnDefinition = "VARCHAR(200) COMMENT '设备名称'")
    private String deviceName;

    @Column(name = "device_id",columnDefinition = "VARCHAR(20) COMMENT '固资编号'")
    private String deviceId;

    @Column(name = "device_type",columnDefinition = "VARCHAR(20) COMMENT '规格型号'")
    private String deviceType;

    @Column(name = "manufacturer",columnDefinition = "VARCHAR(20) COMMENT '品牌'")
    private String manufacturer;

    /**
     * 2次/年
     * 按月
     */
    @Column(name = "service_cycle",columnDefinition = "VARCHAR(50) COMMENT '保养周期'")
    private String serviceCycle;

    /**
     * M
     * Y
     * Q
     */
    @Column(name = "service_result1",columnDefinition = "VARCHAR(20) COMMENT '1月保养结果'")
    private String serviceResult1;
    @Column(name = "service_result2",columnDefinition = "VARCHAR(20) COMMENT '2月保养结果'")
    private String serviceResult2;
    @Column(name = "service_result3",columnDefinition = "VARCHAR(20) COMMENT '3月保养结果'")
    private String serviceResult3;
    @Column(name = "service_result4",columnDefinition = "VARCHAR(20) COMMENT '4月保养结果'")
    private String serviceResult4;
    @Column(name = "service_result5",columnDefinition = "VARCHAR(20) COMMENT '5月保养结果'")
    private String serviceResult5;
    @Column(name = "service_result6",columnDefinition = "VARCHAR(20) COMMENT '6月保养结果'")
    private String serviceResult6;
    @Column(name = "service_result7",columnDefinition = "VARCHAR(20) COMMENT '7月保养结果'")
    private String serviceResult7;
    @Column(name = "service_result8",columnDefinition = "VARCHAR(20) COMMENT '8月保养结果'")
    private String serviceResult8;
    @Column(name = "service_result9",columnDefinition = "VARCHAR(20) COMMENT '9月保养结果'")
    private String serviceResult9;
    @Column(name = "service_result10",columnDefinition = "VARCHAR(20) COMMENT '10月保养结果'")
    private String serviceResult10;
    @Column(name = "service_result11",columnDefinition = "VARCHAR(20) COMMENT '11月保养结果'")
    private String serviceResult11;
    @Column(name = "service_result12",columnDefinition = "VARCHAR(20) COMMENT '12月保养结果'")
    private String serviceResult12;

    /**
     * 已报废
     * 正常
     */
    @Column(name = "device_state",columnDefinition = "VARCHAR(20) COMMENT '设备状态'")
    private String deviceState;

    @Column(name = "scrapped_date",columnDefinition = "datetime COMMENT '报废日期'")
    private Date scrappedDate;

    @Column(name = "vendor",columnDefinition = "VARCHAR(20) COMMENT '供应商'")
    private String vendor;

    @Column(name = "contact",columnDefinition = "VARCHAR(20) COMMENT '联系人'")
    private String contact;

    @Column(name = "telephone",columnDefinition = "VARCHAR(20) COMMENT '联系方式'")
    private String telephone;

    @Column(name = "location",columnDefinition = "VARCHAR(20) COMMENT '安装位置'")
    private String location;

    /**
     * S
     * K
     * N
     */
    @Column(name = "category",columnDefinition = "VARCHAR(20) COMMENT '设备类别'")
    private String category;

    @Column(name = "contract_id",columnDefinition = "VARCHAR(20) COMMENT '采购编号'")
    private String contractId;

    @Column(name = "contract_date",columnDefinition = "datetime COMMENT '采购日期'")
    private Date contractDate;
}
